<%-- 
    Document   : jobid_result
    Created on : Apr 15, 2012, 3:08:39 PM
    Author     : Vishwakarma
--%>

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%@include file="header.jsp" %>
<%try{
   Connection con=Dbconn.getConn();
   String jobid="";
   jobid=request.getParameter("jobid");
   Statement st=con.createStatement();
   String   sql="select student.username,student.name,job_applied.jobid,jobtitle,clgname,compname,result from jobs,college,student,job_applied,company where job_applied.jobid='"+jobid+"' and job_applied.jobid=jobs.jobid and job_applied.username=student.username and student.clgid=college.clgid and jobs.compid=company.compid ";
   ResultSet rs=st.executeQuery(sql);
%>


<table width="100%" border="0" cellpadding="0" cellspacing="0" style="width:960px; height:auto;">
    <tr>
        <td align="left" valign="top">

            <span class='messagesred' style="text-align:center" >
            </span>

            <table width="100%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;">Result of Successful Candidate!!</span></td>
                </tr>
                <tr>
                    <td height="10" align="left" valign="top" class="normal"></td>
                </tr>
                <tr>
                    <td height="26" align="left" valign="top" class="normal">
                        <table width="100%" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue">
                                <td width="3%" align="left" valign="middle"><img style="margin-top:-5px; margin-left:-5px;" src="./images/top_left.gif";/></td>
                                <td width="11%" align="left" valign="middle" class="subjeading">Photo</td>
                              <td width="22%" align="left" valign="middle" class="subjeading"> Name</td>
                              <td width="20%" align="left" valign="middle" class="subjeading">Job Title</td>
                              <td width="15%" align="left" valign="middle" class="subjeading">Company</td>
                              <td width="29%" align="left" valign="middle" class="subjeading">College </td>
                              
                          </tr>

          <%while(rs.next()){ %>
                            <tr class="greybg">
                                <td align="center" valign="top">&nbsp;</td>
                                <td align="left" valign="top"><img src="./src/getpic.jsp?id=<%=rs.getString("student.username")%>&table=student&col=photo&pk_col=username" width="50" height="50" border="0" /></td>
                                <td align="left" valign="top" ><%= rs.getString("name") %></a></td>
                                <td align="left" valign="top"><%= rs.getString("jobtitle")%></td>
                                <td align="left" valign="top"><%=rs.getString("compname")%></td>
                                <td align="left" valign="top"><%=rs.getString("clgname")%></td>
                                
<%}%>
                  </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<%}catch(Exception e){
out.println("<font color=\"black\">"+e+"</font>");
}%>
<%@include file="footer.jsp" %>